3. Enter the following command to uncompress the file:
gunzip -c filename.tar.gz | tar -xvf -
where filename is the fix pack you are installing.
Note: gunzip is part of the AIX 5L™ default installation setup. If you do not have gunzip, install the
rpm.rte fileset from the AIX 5L installation media. The rpm.rte fileset contains gunzip. You can also
download gzip for AIX 5L from Web site:
http://www.ibm.com/servers/aix/products/aixos/linux/rpmgroups.html
Backing up DB2 server configuration and diagnostic information
Backing up your settings for database and database manager configuration parameters before DB2® server
migration, allows you to verify DB2 server behavior after migration, and to re-create instances and databases.
In addition, you can collect information from your DB2 servers about the database system catalogs, DB2
registry variables settings, explain table data, and diagnostic information that can help in problem determination
if you encounter any post-migration differences in the database manager behavior or performance.
Prerequisite
You must activate the database prior to running db2support, otherwise the information collected does
not contain enough information.
You must have SYSADM authority in order to execute all of the following tasks, although some tasks
require lesser authority privileges or none.
Procedure
To back up your DB2 server configuration and diagnostic information:
1. Run the db2support command, for all your databases that you are going to migrate in all
your instances, to collect information from your DB2 servers. This command allows you to
collect information on the database system catalog, database and database manager
configuration parameters settings, DB2 registry variables settings, explain table data, and
diagnostic information required by DB2 support in case of problems.
db2support output-directory -d database-name -cl 0
The -cl 0 parameter collects the database system catalog, database and database manager
configuration parameters settings, DB2 registry variables settings. The information collected is
stored in the db2support.zip compressed zip file under the output directory. A summary report in
HTML format is included. In the db2supp_opt.zip file that is also included, you should check the
optimizer.log file to verify that the collection of information was performed successfully.
It is important that you keep this zip file after you complete the migration for several months. The
information in the zip file can help in quickly resolving any performance issues with the new
release.
2. Back up the information about all the packages for your applications associated with each
database. Use the following command to list packages associated with your databases and
redirect the command output to a file: